home *** CD-ROM | disk | FTP | other *** search
/ SGI Freeware 1999 August / SGI Freeware 1999 August.iso / dist / fw_gnats.idb / usr / freeware / lib / gnats / contrib / sql / Iprms.cust.z / Iprms.cust
Encoding:
Text File  |  1999-04-16  |  709 b   |  29 lines
  1. #!/bin/sh
  2.  
  3. # set up
  4.  
  5. PATH=.:/bin:/usr/bin:/usr/unsupported/bin:/usr/unsupported/informix/bin
  6. INFORMIXDIR=/usr/unsupported/informix
  7. DBPATH=/users/db/infx
  8. DBTEMP=/tmp
  9.  
  10. export PATH
  11. export INFORMIXDIR
  12. export DBPATH
  13. export DBTEMP
  14.  
  15. BUGDIR=/users/db/reports
  16. INFX=/usr/unsupported/informix/bin
  17.  
  18. #------------------------------------------------------------------------
  19. # run customer report and cut off the informix header
  20. # before putting into the correctly named file
  21. #------------------------------------------------------------------------
  22.  
  23. for cust in customer1 customer2 customer3
  24.   do
  25.     CUSTABBR=`echo $cust | cut -c1-3`
  26.     $INFX/sacego bcust $cust | sed -n '7,$p' > $BUGDIR/$CUSTABBR`date +%y%m%d`
  27.   done
  28.  
  29.